Pandas Profiling Report

Dataset statistics

Number of variables	10
Number of observations	2768
Missing cells	0
Missing cells (%)	0.0%
Duplicate rows	0
Duplicate rows (%)	0.0%
Total size in memory	216.4 KiB
Average record size in memory	80.0 B

Variable types

Numeric	9
Categorical	1

Alerts

`Pregnancies` is highly overall correlated with `Age`	High correlation
`SkinThickness` is highly overall correlated with `Insulin`	High correlation
`Insulin` is highly overall correlated with `SkinThickness`	High correlation
`Age` is highly overall correlated with `Pregnancies`	High correlation
`Id` is uniformly distributed	Uniform
`Id` has unique values	Unique
`Pregnancies` has 412 (14.9%) zeros	Zeros
`BloodPressure` has 125 (4.5%) zeros	Zeros
`SkinThickness` has 800 (28.9%) zeros	Zeros
`Insulin` has 1330 (48.0%) zeros	Zeros
`BMI` has 39 (1.4%) zeros	Zeros

Reproduction

Analysis started	2023-09-20 03:47:12.882955
Analysis finished	2023-09-20 03:47:42.865202
Duration	29.98 seconds
Software version	pandas-profiling v3.6.6
Download configuration	config.json

Id
Real number (ℝ)

UNIFORM UNIQUE

Distinct	2768
Distinct (%)	100.0%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	1384.5

Minimum	1
Maximum	2768
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	21.8 KiB

Quantile statistics

Minimum	1
5-th percentile	139.35
Q1	692.75
median	1384.5
Q3	2076.25
95-th percentile	2629.65
Maximum	2768
Range	2767
Interquartile range (IQR)	1383.5

Descriptive statistics

Standard deviation	799.1971
Coefficient of variation (CV)	0.57724601
Kurtosis	-1.2
Mean	1384.5
Median Absolute Deviation (MAD)	692
Skewness	0
Sum	3832296
Variance	638716
Monotonicity	Strictly increasing

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
1	1	< 0.1%
1850	1	< 0.1%
1842	1	< 0.1%
1843	1	< 0.1%
1844	1	< 0.1%
1845	1	< 0.1%
1846	1	< 0.1%
1847	1	< 0.1%
1848	1	< 0.1%
1849	1	< 0.1%
Other values (2758)	2758	99.6%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
1	1	< 0.1%
2	1	< 0.1%
3	1	< 0.1%
4	1	< 0.1%
5	1	< 0.1%
6	1	< 0.1%
7	1	< 0.1%
8	1	< 0.1%
9	1	< 0.1%
10	1	< 0.1%

Value	Count	Frequency (%)
2768	1	< 0.1%
2767	1	< 0.1%
2766	1	< 0.1%
2765	1	< 0.1%
2764	1	< 0.1%
2763	1	< 0.1%
2762	1	< 0.1%
2761	1	< 0.1%
2760	1	< 0.1%
2759	1	< 0.1%

Pregnancies
Real number (ℝ)

HIGH CORRELATION ZEROS

Distinct	17
Distinct (%)	0.6%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	3.7427746

Minimum	0
Maximum	17
Zeros	412
Zeros (%)	14.9%
Negative	0
Negative (%)	0.0%
Memory size	21.8 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	1
median	3
Q3	6
95-th percentile	10
Maximum	17
Range	17
Interquartile range (IQR)	5

Descriptive statistics

Standard deviation	3.323801
Coefficient of variation (CV)	0.88805802
Kurtosis	0.33358506
Mean	3.7427746
Median Absolute Deviation (MAD)	2
Skewness	0.95909632
Sum	10360
Variance	11.047653
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=17)

Value	Count	Frequency (%)
1	491	17.7%
0	412	14.9%
2	387	14.0%
3	270	9.8%
4	259	9.4%
5	198	7.2%
6	181	6.5%
7	145	5.2%
8	134	4.8%
9	98	3.5%
Other values (7)	193	7.0%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	412	14.9%
1	491	17.7%
2	387	14.0%
3	270	9.8%
4	259	9.4%
5	198	7.2%
6	181	6.5%
7	145	5.2%
8	134	4.8%
9	98	3.5%

Value	Count	Frequency (%)
17	4	0.1%
15	3	0.1%
14	9	0.3%
13	32	1.2%
12	32	1.2%
11	35	1.3%
10	78	2.8%
9	98	3.5%
8	134	4.8%
7	145	5.2%

Glucose
Real number (ℝ)

Distinct	136
Distinct (%)	4.9%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	121.1026

Minimum	0
Maximum	199
Zeros	18
Zeros (%)	0.7%
Negative	0
Negative (%)	0.0%
Memory size	21.8 KiB

Quantile statistics

Minimum	0
5-th percentile	79.35
Q1	99
median	117
Q3	141
95-th percentile	181
Maximum	199
Range	199
Interquartile range (IQR)	42

Descriptive statistics

Standard deviation	32.036508
Coefficient of variation (CV)	0.26454022
Kurtosis	0.57911716
Mean	121.1026
Median Absolute Deviation (MAD)	20
Skewness	0.16286439
Sum	335212
Variance	1026.3379
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
99	66	2.4%
100	61	2.2%
102	52	1.9%
129	51	1.8%
106	50	1.8%
95	49	1.8%
112	49	1.8%
105	47	1.7%
111	47	1.7%
108	46	1.7%
Other values (126)	2250	81.3%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	18	0.7%
44	3	0.1%
56	4	0.1%
57	7	0.3%
61	4	0.1%
62	3	0.1%
65	4	0.1%
67	3	0.1%
68	10	0.4%
71	13	0.5%

Value	Count	Frequency (%)
199	4	0.1%
198	3	0.1%
197	12	0.4%
196	8	0.3%
195	10	0.4%
194	13	0.5%
193	8	0.3%
191	3	0.1%
190	4	0.1%
189	12	0.4%

BloodPressure
Real number (ℝ)

Distinct	47
Distinct (%)	1.7%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	69.134393

Minimum	0
Maximum	122
Zeros	125
Zeros (%)	4.5%
Negative	0
Negative (%)	0.0%
Memory size	21.8 KiB

Quantile statistics

Minimum	0
5-th percentile	40
Q1	62
median	72
Q3	80
95-th percentile	90
Maximum	122
Range	122
Interquartile range (IQR)	18

Descriptive statistics

Standard deviation	19.231438
Coefficient of variation (CV)	0.27817469
Kurtosis	5.2750775
Mean	69.134393
Median Absolute Deviation (MAD)	8
Skewness	-1.8504501
Sum	191364
Variance	369.84821
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=47)

Value	Count	Frequency (%)
70	201	7.3%
74	197	7.1%
78	173	6.2%
68	170	6.1%
64	163	5.9%
72	162	5.9%
80	138	5.0%
76	132	4.8%
60	129	4.7%
62	128	4.6%
Other values (37)	1175	42.4%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	125	4.5%
24	3	0.1%
30	5	0.2%
38	4	0.1%
40	3	0.1%
44	15	0.5%
46	8	0.3%
48	18	0.7%
50	44	1.6%
52	40	1.4%

Value	Count	Frequency (%)
122	4	0.1%
114	4	0.1%
110	10	0.4%
108	7	0.3%
106	12	0.4%
104	7	0.3%
102	4	0.1%
100	12	0.4%
98	11	0.4%
96	12	0.4%

SkinThickness
Real number (ℝ)

HIGH CORRELATION ZEROS

Distinct	53
Distinct (%)	1.9%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	20.824422

Minimum	0
Maximum	110
Zeros	800
Zeros (%)	28.9%
Negative	0
Negative (%)	0.0%
Memory size	21.8 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	23
Q3	32
95-th percentile	44
Maximum	110
Range	110
Interquartile range (IQR)	32

Descriptive statistics

Standard deviation	16.059596
Coefficient of variation (CV)	0.77119047
Kurtosis	-0.025897797
Mean	20.824422
Median Absolute Deviation (MAD)	12
Skewness	0.18084092
Sum	57642
Variance	257.91061
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	800	28.9%
32	114	4.1%
30	102	3.7%
23	82	3.0%
27	81	2.9%
28	74	2.7%
18	74	2.7%
33	71	2.6%
39	70	2.5%
31	69	2.5%
Other values (43)	1231	44.5%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	800	28.9%
7	5	0.2%
8	8	0.3%
10	18	0.7%
11	20	0.7%
12	28	1.0%
13	41	1.5%
14	21	0.8%
15	47	1.7%
16	21	0.8%

Value	Count	Frequency (%)
110	2	0.1%
99	3	0.1%
63	4	0.1%
60	3	0.1%
59	2	0.1%
56	4	0.1%
54	6	0.2%
52	6	0.2%
51	4	0.1%
50	10	0.4%

Insulin
Real number (ℝ)

HIGH CORRELATION ZEROS

Distinct	187
Distinct (%)	6.8%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	80.12789

Minimum	0
Maximum	846
Zeros	1330
Zeros (%)	48.0%
Negative	0
Negative (%)	0.0%
Memory size	21.8 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	37
Q3	130
95-th percentile	293
Maximum	846
Range	846
Interquartile range (IQR)	130

Descriptive statistics

Standard deviation	112.30193
Coefficient of variation (CV)	1.4015336
Kurtosis	5.76048
Mean	80.12789
Median Absolute Deviation (MAD)	37
Skewness	2.0781108
Sum	221794
Variance	12611.724
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	1330	48.0%
105	42	1.5%
140	33	1.2%
130	31	1.1%
180	30	1.1%
120	29	1.0%
100	27	1.0%
94	24	0.9%
135	23	0.8%
76	22	0.8%
Other values (177)	1177	42.5%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	1330	48.0%
14	4	0.1%
15	4	0.1%
16	4	0.1%
18	7	0.3%
22	4	0.1%
23	6	0.2%
25	3	0.1%
29	4	0.1%
32	3	0.1%

Value	Count	Frequency (%)
846	1	< 0.1%
744	3	0.1%
680	3	0.1%
600	3	0.1%
579	5	0.2%
545	3	0.1%
543	1	< 0.1%
540	4	0.1%
510	4	0.1%
495	7	0.3%

BMI
Real number (ℝ)

Distinct	253
Distinct (%)	9.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	32.137392

Minimum	0
Maximum	80.6
Zeros	39
Zeros (%)	1.4%
Negative	0
Negative (%)	0.0%
Memory size	21.8 KiB

Quantile statistics

Minimum	0
5-th percentile	21.8
Q1	27.3
median	32.2
Q3	36.625
95-th percentile	44.6
Maximum	80.6
Range	80.6
Interquartile range (IQR)	9.325

Descriptive statistics

Standard deviation	8.0761272
Coefficient of variation (CV)	0.25130002
Kurtosis	3.9233175
Mean	32.137392
Median Absolute Deviation (MAD)	4.7
Skewness	-0.17657571
Sum	88956.3
Variance	65.223831
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
32	46	1.7%
31.2	45	1.6%
31.6	41	1.5%
0	39	1.4%
33.3	37	1.3%
32.4	35	1.3%
32.8	34	1.2%
30.8	33	1.2%
32.9	33	1.2%
30.1	31	1.1%
Other values (243)	2394	86.5%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	39	1.4%
18.2	11	0.4%
18.4	3	0.1%
19.1	3	0.1%
19.3	4	0.1%
19.4	3	0.1%
19.5	8	0.3%
19.6	9	0.3%
19.9	1	< 0.1%
20	4	0.1%

Value	Count	Frequency (%)
80.6	2	0.1%
67.1	4	0.1%
64.4	2	0.1%
59.4	4	0.1%
57.3	4	0.1%
55	4	0.1%
53.2	4	0.1%
52.9	4	0.1%
52.7	2	0.1%
52.3	6	0.2%

DiabetesPedigreeFunction
Real number (ℝ)

Distinct	523
Distinct (%)	18.9%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	0.47119256

Minimum	0.078
Maximum	2.42
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	21.8 KiB

Quantile statistics

Minimum	0.078
5-th percentile	0.141
Q1	0.244
median	0.375
Q3	0.624
95-th percentile	1.136
Maximum	2.42
Range	2.342
Interquartile range (IQR)	0.38

Descriptive statistics

Standard deviation	0.32566883
Coefficient of variation (CV)	0.69115869
Kurtosis	5.172935
Mean	0.47119256
Median Absolute Deviation (MAD)	0.168
Skewness	1.8427907
Sum	1304.261
Variance	0.10606019
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0.258	22	0.8%
0.207	20	0.7%
0.261	18	0.7%
0.268	18	0.7%
0.238	18	0.7%
0.259	17	0.6%
0.284	16	0.6%
0.551	16	0.6%
0.52	16	0.6%
0.292	16	0.6%
Other values (513)	2591	93.6%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0.078	3	0.1%
0.084	3	0.1%
0.085	7	0.3%
0.088	8	0.3%
0.089	3	0.1%
0.092	3	0.1%
0.096	4	0.1%
0.1	4	0.1%
0.101	3	0.1%
0.102	3	0.1%

Value	Count	Frequency (%)
2.42	4	0.1%
2.329	3	0.1%
2.288	1	< 0.1%
2.137	4	0.1%
1.893	3	0.1%
1.781	3	0.1%
1.731	4	0.1%
1.699	3	0.1%
1.698	4	0.1%
1.6	4	0.1%

Age
Real number (ℝ)

Distinct	52
Distinct (%)	1.9%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	33.132225

Minimum	21
Maximum	81
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	21.8 KiB

Quantile statistics

Minimum	21
5-th percentile	21
Q1	24
median	29
Q3	40
95-th percentile	58
Maximum	81
Range	60
Interquartile range (IQR)	16

Descriptive statistics

Standard deviation	11.77723
Coefficient of variation (CV)	0.35546148
Kurtosis	0.77185874
Mean	33.132225
Median Absolute Deviation (MAD)	7
Skewness	1.1662989
Sum	91710
Variance	138.70315
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
22	264	9.5%
21	229	8.3%
25	182	6.6%
24	168	6.1%
23	141	5.1%
28	133	4.8%
26	117	4.2%
27	113	4.1%
29	99	3.6%
31	82	3.0%
Other values (42)	1240	44.8%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
21	229	8.3%
22	264	9.5%
23	141	5.1%
24	168	6.1%
25	182	6.6%
26	117	4.2%
27	113	4.1%
28	133	4.8%
29	99	3.6%
30	77	2.8%

Value	Count	Frequency (%)
81	4	0.1%
72	4	0.1%
70	4	0.1%
69	8	0.3%
68	4	0.1%
67	13	0.5%
66	16	0.6%
65	11	0.4%
64	4	0.1%
63	17	0.6%

Outcome
Categorical

Distinct	2
Distinct (%)	0.1%
Missing	0
Missing (%)	0.0%
Memory size	21.8 KiB

0	1816
1	952

Length

Max length	1
Median length	1
Mean length	1
Min length	1

Characters and Unicode

Total characters	2768
Distinct characters	2
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	1
2nd row	0
3rd row	1
4th row	0
5th row	1

Common Values

Value	Count	Frequency (%)
0	1816	65.6%
1	952	34.4%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
0	1816	65.6%
1	952	34.4%

Most occurring characters

Value	Count	Frequency (%)
0	1816	65.6%
1	952	34.4%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	2768	100.0%

Most frequent character per category

Decimal Number

Value	Count	Frequency (%)
0	1816	65.6%
1	952	34.4%

Most occurring scripts

Value	Count	Frequency (%)
Common	2768	100.0%

Most frequent character per script

Common

Value	Count	Frequency (%)
0	1816	65.6%
1	952	34.4%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	2768	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
0	1816	65.6%
1	952	34.4%

Auto

Heatmap
Table

	Id	Pregnancies	Glucose	BloodPressure	SkinThickness	Insulin	BMI	DiabetesPedigreeFunction	Age	Outcome
Id	1.000	-0.023	0.013	0.010	0.015	0.015	0.018	-0.003	-0.008	0.044
Pregnancies	-0.023	1.000	0.119	0.180	-0.076	-0.132	-0.005	-0.041	0.601	0.249
Glucose	0.013	0.119	1.000	0.223	0.069	0.220	0.228	0.077	0.274	0.490
BloodPressure	0.010	0.180	0.223	1.000	0.142	-0.007	0.288	0.029	0.350	0.188
SkinThickness	0.015	-0.076	0.069	0.142	1.000	0.536	0.462	0.177	-0.058	0.202
Insulin	0.015	-0.132	0.220	-0.007	0.536	1.000	0.212	0.229	-0.121	0.172
BMI	0.018	-0.005	0.228	0.288	0.462	0.212	1.000	0.139	0.125	0.305
DiabetesPedigreeFunction	-0.003	-0.041	0.077	0.029	0.177	0.229	0.139	1.000	0.039	0.186
Age	-0.008	0.601	0.274	0.350	-0.058	-0.121	0.125	0.039	1.000	0.330
Outcome	0.044	0.249	0.490	0.188	0.202	0.172	0.305	0.186	0.330	1.000

Count
Matrix

A simple visualization of nullity by column.

Nullity matrix is a data-dense display which lets you quickly visually pick out patterns in data completion.

First rows
Last rows

	Id	Pregnancies	Glucose	BloodPressure	SkinThickness	Insulin	BMI	DiabetesPedigreeFunction	Age	Outcome
0	1	6	148	72	35	0	33.6	0.627	50	1
1	2	1	85	66	29	0	26.6	0.351	31	0
2	3	8	183	64	0	0	23.3	0.672	32	1
3	4	1	89	66	23	94	28.1	0.167	21	0
4	5	0	137	40	35	168	43.1	2.288	33	1
5	6	5	116	74	0	0	25.6	0.201	30	0
6	7	3	78	50	32	88	31.0	0.248	26	1
7	8	10	115	0	0	0	35.3	0.134	29	0
8	9	2	197	70	45	543	30.5	0.158	53	1
9	10	8	125	96	0	0	0.0	0.232	54	1

	Id	Pregnancies	Glucose	BloodPressure	SkinThickness	Insulin	BMI	DiabetesPedigreeFunction	Age	Outcome
2758	2759	3	111	90	12	78	28.4	0.495	29	0
2759	2760	6	102	82	0	0	30.8	0.180	36	1
2760	2761	6	134	70	23	130	35.4	0.542	29	1
2761	2762	2	87	0	23	0	28.9	0.773	25	0
2762	2763	1	79	60	42	48	43.5	0.678	23	0
2763	2764	2	75	64	24	55	29.7	0.370	33	0
2764	2765	8	179	72	42	130	32.7	0.719	36	1
2765	2766	6	85	78	0	0	31.2	0.382	42	0
2766	2767	0	129	110	46	130	67.1	0.319	26	1
2767	2768	2	81	72	15	76	30.1	0.547	25	0

Overview

Variables

Common Values

Length

Common Values (Plot)

Most occurring characters

Most occurring categories

Most frequent character per category

Decimal Number

Most occurring scripts

Most frequent character per script

Common

Most occurring blocks

Most frequent character per block

ASCII

Interactions

Correlations

Missing values

Sample